package cn.nbt.busManage.dao.mapper;

import cn.nbt.busManage.model.dto.RouteDto;
import cn.nbt.busManage.model.entity.Route;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * {@code @Author} lyq
 * {@code @Date} 6/13/2024 7:13 PM
 */

@Mapper
public interface RouteMapper {

    /**
     * 根据站点id查询线路
     * @param pointId 站点id
     * @return 线路信息
     */
    @Select("select * from route where route.points like '%${pointId}%'")
    List<Route> findByPoindId(Integer pointId);
}
